﻿CREATE TABLE [dbo].[Currency] (
    [Id]                 UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [Name]               NVARCHAR (64)    NOT NULL,
    [ShortName]          NVARCHAR (6)     NOT NULL,
    [Symbol]             NVARCHAR (6)     NOT NULL,
    [IsDisable]          BIT              DEFAULT ((0)) NOT NULL,
    [LastModifiedTime]   DATETIME         NOT NULL,
    [LastModifiedUserID] UNIQUEIDENTIFIER NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK5C53315B11E65B0E] FOREIGN KEY ([LastModifiedUserID]) REFERENCES [dbo].[UserProfile] ([ID])
);

